To enter a SQL verification calculation
If you enter a SQL Registration Verification Calculation, iMIS tests a registrant's eligibility based on the requirements defined in the calculation. The SQL calculation results in either a 1 or a 0. If the result is a 1, then iMIS enables you to create an order for the registrant. If the result is a 0, then a message is displayed indicating that the registrant is not eligible, and the registration is canceled.
The following is a sample calculation (the calculation varies from organization to organization). The sample calculation searches for all CM (company member) types, and, if the registrant is not a CM, iMIS displays a message indicating that the registration cannot be processed.
select COUNT(*) from Name where MEMBER_TYPE='CM' and ID = [AsiSQL(Orders.ST_ID)]
10.6 Production Release. Updated 1/12/2006 4:31:48 PM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.